SELECT ifnull(Event,'<NULL>') AS E FROM Games GROUP BY E;
Najdorf Memorial 2014 - gr.A
----
SELECT ifnull(Site,'<NULL>') AS S FROM Games GROUP BY S;
Warszawa
----
SELECT ifnull(EventDate,'<NULL>') AS ED FROM Games GROUP BY ED;
2014.07.14
----
SELECT ifnull(TimeControl,'<NULL>') AS T FROM Games GROUP BY T;
40/5400:1800+30
----
SELECT count(*) from Games WHERE length(game) < 10;
0
----
SELECT count(*) from Games WHERE ECO ISNULL OR ECO='?';
50
----
